/**
* Copyright (C) 2018-2020
* All rights reserved, Designed By www.yixiang.co
* 注意：
* 本软件为www.yixiang.co开发研制，未经购买不得使用
* 购买后可获得全部源代码（禁止转卖、分享、上传到码云、github等开源平台）
* 一经发现盗用、分享等行为，将追究法律责任，后果自负
*/
package co.yixiang.modules.appdict.service.mapper;

import co.yixiang.common.mapper.CoreMapper;
import co.yixiang.modules.appdict.domain.Appdict;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* @author yhh
* @date 2020-08-07
*/
@Repository
public interface AppdictMapper extends CoreMapper<Appdict> {

    @Select("select z.* from yx_appdict z where z.parent_oid=(select a.oid from yx_appdict a where a.code=#{code})")
    List<Appdict> findListByCode(@Param("code") String code);

    @Select("select a.* from yx_appdict a where a.code=#{code}")
    Appdict findOneByCode(@Param("code") String code);

    @Select("select * from yx_appdict where code=#{code}")
    Appdict getByCode(String sxf);
}
